|
((if ('debtor'.'reporting agent identifier' = 'counterparty'.'reporting agent identifier' and
'debtor'.'counterparty role' = "debtor" and
'debtor'.'counterparty identifier' = 'counterparty'.'counterparty identifier' and
'debtor'.'reporting reference date' = 'counterparty'.'reporting reference date' and
'counterparty'.'legal entity indicator' = "legal entity" and
'counterparty'.'reporting agent identifier' = 'legal entity'.'reporting agent identifier' and
'counterparty'.'counterparty identifier' = 'legal entity'.'counterparty identifier' and
'counterparty'.'reporting reference date' = 'legal entity'.'reporting reference date' and
(('legal entity'.'resident legal entity indicator' = "foreign legal entity" and
'legal entity'.'reporting agent identifier' = 'foreign legal entity'.'reporting agent identifier' and
'legal entity'.'counterparty identifier' = 'foreign legal entity'.'counterparty identifier' and
'legal entity'.'reporting reference date' = 'foreign legal entity'.'reporting reference date' and
'foreign legal entity'.'foreign legal entity in reporting member state indicator' = "foreign legal entity in reporting member state") or
('counterparty'.'resident counterparty indicator' = "Dutch counterparty")))
then
('debtor'.'immediate parent undertaking identifier' <> Null))
and
(if ('protection provider'.'reporting agent identifier' = 'counterparty'.'reporting agent identifier' and
'protection provider'.'counterparty identifier' = 'counterparty'.'counterparty identifier' and
'protection provider'.'reporting reference date' = 'counterparty'.'reporting reference date' and
'counterparty'.'legal entity indicator' = "legal entity" and
'counterparty'.'reporting agent identifier' = 'legal entity'.'reporting agent identifier' and
'counterparty'.'counterparty identifier' = 'legal entity'.'counterparty identifier' and
'counterparty'.'reporting reference date' = 'legal entity'.'reporting reference date' and
(('legal entity'.'resident legal entity indicator' = "foreign legal entity" and
'legal entity'.'reporting agent identifier' = 'foreign legal entity'.'reporting agent identifier' and
'legal entity'.'counterparty identifier' = 'foreign legal entity'.'counterparty identifier' and
'legal entity'.'reporting reference date' = 'foreign legal entity'.'reporting reference date' and
'foreign legal entity'.'foreign legal entity in reporting member state indicator' = "foreign legal entity in reporting member state") or
('counterparty'.'resident counterparty indicator' = "Dutch counterparty")))
then
('protection provider'.'immediate parent undertaking identifier' <> Null)))
|